<!DOCTYPE html>
<!-- saved from url=(0050)https://www.cnblogs.com/winton-nfs/p/11524007.html -->
<html lang="zh-cn" class="windows desktop landscape"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta name="referrer" content="origin">
    <meta name="description" content="免安装版的Mysql MySQL关是一种关系数据库管理系统，所使用的 SQL 语言是用于访问数据库的最常用的 标准化语言，其特点为体积小、速度快、总体拥有成本低，尤其是开放源码这一特点，在 Web 应">
    <meta property="og:description" content="免安装版的Mysql MySQL关是一种关系数据库管理系统，所使用的 SQL 语言是用于访问数据库的最常用的 标准化语言，其特点为体积小、速度快、总体拥有成本低，尤其是开放源码这一特点，在 Web 应">
    <meta http-equiv="Cache-Control" content="no-transform">
    <meta http-equiv="Cache-Control" content="no-siteapp">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>MySQL的安装与配置——详细教程 - Winton-H - 博客园</title>
    <link id="favicon" rel="shortcut icon" href="https://common.cnblogs.com/favicon.svg" type="image/svg+xml">
    
    <link rel="stylesheet" href="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/blog-common.min.css">
    <link id="MainCss" rel="stylesheet" href="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/bundle-codinglife.min.css">
    <link type="text/css" rel="stylesheet" href="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/custom.css">
    <link id="mobile-style" media="only screen and (max-width: 767px)" type="text/css" rel="stylesheet" href="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/bundle-codinglife-mobile.min.css">
    
    <link type="application/rss+xml" rel="alternate" href="https://www.cnblogs.com/winton-nfs/rss">
    <link type="application/rsd+xml" rel="EditURI" href="https://www.cnblogs.com/winton-nfs/rsd.xml">
    <link type="application/wlwmanifest+xml" rel="wlwmanifest" href="https://www.cnblogs.com/winton-nfs/wlwmanifest.xml">
    <script src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/osd.js"></script><script async="" src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/analytics.js"></script><script>
        var currentBlogId = 523966;
        var currentBlogApp = 'winton-nfs';
        var cb_enable_mathjax = false;
        var isLogined = false;
        var isBlogOwner = false;
        var skinName = 'CodingLife';
        var visitorUserId = '';
    </script>
        <script>
            var currentPostDateAdded = '2019-09-15 08:13';
        </script>
    <script src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/jquery-2.2.0.min.js"></script>
    <script src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/blog-common.min.js"></script>
    
    
    
<script type="text/javascript" charset="utf-8" async="" src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/L2Dwidget.0.min.js"></script><script src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/pubads_impl_2020111701.js" async=""></script><link rel="preload" href="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/f.txt" as="script"><script type="text/javascript" src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/f.txt"></script><link rel="prefetch" href="https://38e3a099a1ccc642ad3fe8ac111e85f0.safeframe.googlesyndication.com/safeframe/1-0-37/html/container.html"></head>
<body class="has-navbar">
    <a name="top"></a>
    <div id="top_nav" class="navbar">
        <nav id="nav_main" class="navbar-main">
            <ul id="nav_left" class="navbar-list navbar-left">
                <li class="navbar-branding"><a href="https://www.cnblogs.com/" title="开发者的网上家园"><img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/logo.svg" alt="博客园Logo"></a></li>
                <li><a href="https://www.cnblogs.com/" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;skin-navbar-sitehome&#39;)">首页</a></li>
                <li><a href="https://news.cnblogs.com/" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;skin-navbar-news&#39;)">新闻</a></li>
                <li><a href="https://q.cnblogs.com/" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;skin-navbar-q&#39;)">博问</a></li>
                <li><a id="nav_brandzone" href="https://brands.cnblogs.com/" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;skin-navbar-brands&#39;)">专区</a></li>
                <li><a href="https://ing.cnblogs.com/" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;skin-navbar-ing&#39;)">闪存</a></li>
                <li><a href="https://edu.cnblogs.com/" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;skin-navbar-edu&#39;)">班级</a></li>
            </ul>
            <ul id="nav_right" class="navbar-list navbar-right">
                <li>
                    <form id="zzk_search" class="navbar-search" action="https://zzk.cnblogs.com/s" method="get">
                        <input name="w" id="zzk_search_input" placeholder="代码改变世界" type="text" tabindex="3">
                        <button type="submit" id="zzk_search_button">
                            <img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/search.svg" alt="搜索">
                        </button>
                    </form>
                </li>
                <li id="navbar_login_status" class="navbar-list">
                    <a id="navblog-myblog-icon" class="navbar-user-info navbar-blog" href="https://passport.cnblogs.com/GetBlogApplyStatus.aspx" alt="我的博客" title="我的博客" style="display: none;">
                        <img id="myblog_icon" class="navbar-icon" src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/myblog.svg" alt="我的博客">
                    </a>
                    <a class="navbar-user-info navbar-message navbar-icon-wrapper" href="https://msg.cnblogs.com/" alt="短消息" title="短消息" style="display: none;">
                        <img id="msg_icon" class="navbar-icon" src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/message.svg" alt="短消息">
                        <span id="msg_count" style="display: none"></span>
                    </a>
                    <div id="user_info" class="navbar-user-info dropdown" style="display: none;">
                        <a class="dropdown-button" href="https://home.cnblogs.com/">
                            <img id="user_icon" class="navbar-avatar" src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/avatar-default.svg" alt="用户头像">
                        </a>
                        <div class="dropdown-menu">
                            <a id="navblog-myblog-text" href="https://passport.cnblogs.com/GetBlogApplyStatus.aspx">我的博客</a>
                            <a href="https://home.cnblogs.com/">我的园子</a>
                            <a href="https://account.cnblogs.com/settings/account">账号设置</a>
                            <a href="javascript:void(0)" onclick="logout();">退出登录</a>
                        </div>
                    </div>
                    <a class="navbar-anonymous" href="https://account.cnblogs.com/signup/" style="display: inline;">注册</a>
                    <a class="navbar-anonymous" href="javascript:void(0);" onclick="login()" style="display: inline;">登录</a>
                </li>
            </ul>
        </nav>
    </div>

    
    <!--done-->
<div id="home">
<div id="header">
	<div id="blogTitle">
        <a id="lnkBlogLogo" href="https://www.cnblogs.com/winton-nfs/"><img id="blogLogo" src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/logo.gif" alt="返回主页"></a>		
		
<!--done-->
<h1><a id="Header1_HeaderTitle" class="headermaintitle HeaderMainTitle" href="https://www.cnblogs.com/winton-nfs/">Winton</a>
</h1>
<h2>

</h2>




		
	</div><!--end: blogTitle 博客的标题和副标题 -->
	<div id="navigator">
		
<ul id="navList">
<li><a id="blog_nav_sitehome" class="menu" href="https://www.cnblogs.com/">
博客园</a>
</li>
<li>
<a id="blog_nav_myhome" class="menu" href="https://www.cnblogs.com/winton-nfs/">
首页</a>
</li>
<li>

<a id="blog_nav_newpost" class="menu" href="https://i.cnblogs.com/EditPosts.aspx?opt=1">
新随笔</a>
</li>
<li>
<a id="blog_nav_contact" class="menu" href="https://msg.cnblogs.com/send/Winton-H">
联系</a></li>
<li>
<a id="blog_nav_rss" class="menu" href="javascript:void(0)" data-rss="https://www.cnblogs.com/winton-nfs/rss/">
订阅</a>
<!--<partial name="./Shared/_XmlLink.cshtml" model="Model" /></li>--></li>
<li>
<a id="blog_nav_admin" class="menu" href="https://i.cnblogs.com/">
管理</a>
</li>
</ul>


		<div class="blogStats">
			<span id="stats_post_count">随笔 - 14&nbsp; </span>
<span id="stats_article_count">文章 - 0&nbsp; </span>
<span id="stats-comment_count">评论 - 80</span>

		</div><!--end: blogStats -->
	</div><!--end: navigator 博客导航栏 -->
</div><!--end: header 头部 -->
<div id="main">
	<div id="mainContent">
	<div class="forFlow">
		<div id="post_detail">
    <!--done-->
    <div id="topics">
        <div class="post">
            <h1 class="postTitle">
                
<a id="cb_post_title_url" class="postTitle2 vertical-middle" href="https://www.cnblogs.com/winton-nfs/p/11524007.html">
    <span>MySQL的安装与配置——详细教程</span>
    


</a>

            </h1>
            <div class="clear"></div>
            <div class="postBody">
                
<div id="cnblogs_post_body" class="blogpost-body">
    <h1>　免安装版的Mysql</h1>
<p>　　<span style="font-family: 黑体; font-size: 15px">MySQL关是一种关系数据库管理系统，所使用的 SQL 语言是用于访问<a href="https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93/103728" target="_blank" data-lemmaid="103728">数据库</a>的最常用的</span></p>
<p><span style="font-family: 黑体; font-size: 15px">标准化语言，其特点为体积小、速度快、总体拥有成本低，尤其是<a href="https://baike.baidu.com/item/%E5%BC%80%E6%94%BE%E6%BA%90%E7%A0%81/7176422" target="_blank" data-lemmaid="7176422">开放源码</a>这一特点，在 Web</span></p>
<p><span style="font-family: 黑体; font-size: 15px"> 应用方面 MySQL 是最好的 RDBMS(Relational Database Management System：关系数据</span></p>
<p><span style="font-family: 黑体; font-size: 15px">库管理系统)应用软件之一。</span></p>
<p>&nbsp;</p>
<p><strong>　　</strong><span style="font-family: 黑体; font-size: 15px">在本博文里，我主要以Mysql免安装版为例，帮助大家解决安装与配置mysql的步骤。</span></p>
<p><span style="font-family: 黑体; font-size: 15px">&nbsp;</span></p>
<p><span style="font-family: 黑体; font-size: 15px">　　首先：要先进入mysql官网里（Mysql的官网--&gt;<a title="Mysql官网" href="https://www.mysql.com/" target="_blank">https://www.mysql.com/</a>），下面是详细步骤：↓</span></p>
<p><span style="font-family: 黑体; font-size: 15px">　　(为了方便大家的操作，我的网盘里有安装包：</span></p>
<p>　　　　链接：<a href="https://pan.baidu.com/s/1LpslLQRNacW2-m3x6odNnQ" target="_blank">https://pan.baidu.com/s/1LpslLQRNacW2-m3x6odNnQ</a><br>　　　　提取码：e39z&nbsp;<br>　　)</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<h2><strong>一：下载安装包：</strong></h2>
<p>&nbsp;</p>
<p><strong>　　</strong><span style="font-family: 黑体; font-size: 15px">①进入官网后，点击"Dowload"，然后页面往下拉</span></p>
<p><strong>　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915192559647-350219166.jpg" alt="" width="1349" height="678"></strong></p>
<p>　　</p>
<p>&nbsp;</p>
<p>　　<span style="font-family: 黑体; font-size: 15px">②接下来看到的页面是这样的，红色框框的链接就是mysql社区版，是免费的mysql版本，然后我们点击这个框框的链接：↓</span></p>
<p>&nbsp;</p>
<p>　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915192752591-1371678378.jpg" alt=""></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>　　　<span style="font-family: 黑体; font-size: 15px"> ③接下来跳转到这个页面，在这里，我们只要下载社区版的Server就可以了：↓</span></p>
<p><img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915193055444-1634354218.jpg" alt=""></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>　　<span style="font-family: 黑体; font-size: 15px">④下载免安装版(windows以外的其他系统除外)</span></p>
<p>&nbsp;</p>
<p><img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915193247068-1867170933.jpg" alt=""></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<h3>　　</h3>
<h3><strong>　</strong>　***这样，安装包就下载好了！</h3>
<h3>　　***注意，安装的目录应当放在指定位置，，其次，绝对路径中避免出现中文，推荐首选英文为命名条件！！！！(我的为参考)</h3>
<p><strong>　　</strong></p>
<p><strong>　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915193949895-2127429091.jpg" alt=""></strong></p>
<p>&nbsp;</p>
<h2><span style="font-size: 16px"><strong>　</strong></span></h2>
<p>　　</p>
<h2><strong>二：Mysql的配置</strong></h2>
<p><strong>　　<span style="font-size: 16px">*以<span style="font-size: 18pt; background-color: rgba(255, 255, 255, 1); color: rgba(255, 0, 0, 1)">管理员身份</span>打开命令行(如下图所示)</span></strong></p>
<p><strong>　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915194138600-1666145922.jpg" alt=""></strong></p>
<p><strong>　　</strong></p>
<p>&nbsp;</p>
<p><strong>　</strong>　<span style="font-family: 黑体; font-size: 15px">①下转到mysql的bin目录下：</span><strong><br></strong></p>
<p>&nbsp;</p>
<p>　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915194319422-1269147823.jpg" alt=""></p>
<p>&nbsp;</p>
<p>　　<span style="font-size: 15px; font-family: 黑体">②安装mysql的服务：mysqld --install</span></p>
<p>&nbsp;</p>
<p>　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915194355509-621408710.jpg" alt=""></p>
<p>　　</p>
<p>&nbsp;</p>
<p>　　<span style="font-family: 黑体; font-size: 15px">③初始化mysql，在这里，初始化会产生一个随机密码,如下图框框所示，记住这个密码，后面会用到(mysqld --initialize --console)</span></p>
<p>　　</p>
<p>　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915194537624-1288770126.jpg" alt=""></p>
<p>　　</p>
<p>　　<span style="font-family: 黑体; font-size: 15px">④开启mysql的服务(net start mysql)</span></p>
<p>&nbsp;</p>
<p>　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915194809019-447378790.jpg" alt=""></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>　　<span style="font-family: 黑体; font-size: 15px">⑤登录验证，mysql是否安装成功！(要注意上面产生的随机密码，不包括前面符号前面的空格，否则会登陆失败)，如果和下图所示一样，则说明你的mysql已经安装成功！注意，，一定要先开启服务，不然会登陆失败，出现拒绝访问的提示符！！！</span></p>
<p>&nbsp;</p>
<p>　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915194855594-1799062186.jpg" alt=""></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>　　</p>
<h4>　　<span style="font-size: 18px">修改密码：</span></h4>
<p><span style="font-size: 16px">　　　　由于初始化产生的随机密码太复杂，，不便于我们登录mysql，因此，我们应当修改一个自己能记住的密码！！</span></p>
<p>&nbsp;</p>
<p><span style="font-size: 16px">　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915195232011-1164270181.jpg" alt=""></span></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p><span style="font-size: 16px">　　再次登录验证新密码：</span></p>
<p>&nbsp;</p>
<p><span style="font-size: 16px">　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915195310138-1959548424.jpg" alt=""></span></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p><span style="font-size: 16px">　　</span><span style="font-size: 18px"><strong>设置系统的全局变量：</strong></span></p>
<p><span style="font-size: 18px"><strong>　　　　</strong><span style="font-size: 16px">为了方便登录操作mysql，在这里我们设置一个全局变量：↓</span></span></p>
<p>&nbsp;</p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　　　①点击"我的电脑"--&gt;"属性"--&gt;''高级系统设置''--&gt;''环境变量'',接下来如下图所操作</span></span></p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　</span></span></p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915195658938-215279743.jpg" alt=""></span></span></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　　　②把新建的mysql变量添加到Path路径变量中，点击确定，即完成：</span></span></p>
<p>&nbsp;</p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915195808186-1920486822.jpg" alt=""></span></span></p>
<p>&nbsp;</p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　　　</span></span></p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　　　配置完成之后，每当我们想要用命令行使用mysql时，只需要win+R，--&gt;输入"cmd"打开命令行，之后输入登录sql语句即可。</span></span></p>
<p>&nbsp;</p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　</span></span></p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　　　③在mysql目录下创建一个ini或cnf配置文件，在这里我创建的是ini配置文件，里面写的代码是mysql的一些基本配置<br></span></span></p>
<p>&nbsp;</p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　　　<img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/1727568-20190915201058332-997469892.jpg" alt=""></span></span></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p><span style="font-size: 18px"><span style="font-size: 16px">　　就这样，一个免安装版的Mysql就安装并配置完成了</span></span></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<h2><span style="font-size: 14pt">可能会出现的问题</span></h2>
<p>&nbsp;1、ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES)&nbsp;</p>
<p>&nbsp;2、"由于找不到MSVCR120.dll，无法继续执行代码。重新安装程序可能会解决此问题" 或者 "由于找不到VCRUNTIME140_1.dll，无法继续执行代码。重新安装程序可能会解决此问题"&nbsp;</p>
<p>&nbsp;</p>
<p><strong>解决办法</strong>：&nbsp; 转移至我另外两篇博客</p>
<p>1、<a class="entry" href="https://www.cnblogs.com/winton-nfs/p/12956811.html" target="_blank">ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES)</a>&nbsp;&nbsp;</p>
<p>2、<a class="entry" href="https://www.cnblogs.com/winton-nfs/p/13854052.html" target="_blank">解决mysql问题：由于找不到MSVCR120.dll,无法继续执行代码.重新安装程序可能会解决此问题。</a>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<h2><strong>命令参考：</strong></h2>
<p>&nbsp;</p>
<h3><strong>　　①安装服务：</strong>mysqld --install</h3>
<h3>&nbsp;</h3>
<h3><strong>　　②<strong>初始化：　</strong></strong>mysqld --initialize --console</h3>
<h3>&nbsp;</h3>
<h3><strong><strong>　　③开启服务：</strong></strong>net start mysql</h3>
<h3>&nbsp;</h3>
<h3><strong><strong>　　④关闭<strong><strong>服务：</strong></strong></strong></strong>net stop mysql</h3>
<h3>&nbsp;</h3>
<h3><strong><strong><strong><strong>　　⑤登录mysql：</strong></strong></strong></strong>mysql -u root -p</h3>
<h3>&nbsp;</h3>
<h3><strong><strong><strong><strong>　　　　Enter PassWord：(</strong></strong></strong></strong>密码<strong><strong><strong><strong>)</strong></strong></strong></strong></h3>
<h3>&nbsp;</h3>
<h3><strong><strong><strong><strong>　　⑥修改密码：</strong></strong></strong></strong>alter user 'root'@'localhost' identified by 'root';(by 接着的是密码)</h3>
<h3>&nbsp;</h3>
<h3>　　<strong>⑦标记删除mysql服务</strong>：sc delete mysql</h3>
<p>&nbsp;</p>
<p>　　</p>
<p>&nbsp;</p>
</div>
<div id="MySignature"></div>
<div class="clear"></div>
<div id="blog_post_info_block"><div id="BlogPostCategory">
    分类: 
            <a href="https://www.cnblogs.com/winton-nfs/category/1543851.html" target="_blank">数据库</a></div>


    <div id="blog_post_info">
<div id="green_channel">
        <a href="javascript:void(0);" id="green_channel_digg" onclick="DiggIt(11524007,cb_blogId,1);green_channel_success(this,&#39;谢谢推荐！&#39;);">好文要顶</a>
        <a id="green_channel_follow" onclick="follow(&#39;355f0e15-6b97-45ad-41c6-08d6f93321fd&#39;);" href="javascript:void(0);">关注我</a>
    <a id="green_channel_favorite" onclick="AddToWz(cb_entryId);return false;" href="javascript:void(0);">收藏该文</a>
    <a id="green_channel_weibo" href="javascript:void(0);" title="分享至新浪微博" onclick="ShareToTsina()"><img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/icon_weibo_24.png" alt=""></a>
    <a id="green_channel_wechat" href="javascript:void(0);" title="分享至微信" onclick="shareOnWechat()"><img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/wechat.png" alt=""></a>
</div>
<div id="author_profile">
    <div id="author_profile_info" class="author_profile_info">
            <a href="https://home.cnblogs.com/u/winton-nfs/" target="_blank"><img src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/20190627202545.png" class="author_avatar" alt=""></a>
        <div id="author_profile_detail" class="author_profile_info">
            <a href="https://home.cnblogs.com/u/winton-nfs/">Winton-H</a><br>
            <a href="https://home.cnblogs.com/u/winton-nfs/followees/">关注 - 9</a><br>
            <a href="https://home.cnblogs.com/u/winton-nfs/followers/">粉丝 - 68</a>
        </div>
    </div>
    <div class="clear"></div>
    <div id="author_profile_honor"></div>
    <div id="author_profile_follow">
                <a href="javascript:void(0);" onclick="follow(&#39;355f0e15-6b97-45ad-41c6-08d6f93321fd&#39;);return false;">+加关注</a>
    </div>
</div>
<div id="div_digg">
    <div class="diggit" onclick="votePost(11524007,&#39;Digg&#39;)">
        <span class="diggnum" id="digg_count">63</span>
    </div>
    <div class="buryit" onclick="votePost(11524007,&#39;Bury&#39;)">
        <span class="burynum" id="bury_count">0</span>
    </div>
    <div class="clear"></div>
    <div class="diggword" id="digg_tips">
    </div>
</div>

<script type="text/javascript">
    currentDiggType = 0;
</script></div>
    <div class="clear"></div>
    <div id="post_next_prev">

    <a href="https://www.cnblogs.com/winton-nfs/p/11461240.html" class="p_n_p_prefix">« </a> 上一篇：    <a href="https://www.cnblogs.com/winton-nfs/p/11461240.html" title="发布于 2019-09-04 19:51">JavaWeb实现修改功能</a>
    <br>
    <a href="https://www.cnblogs.com/winton-nfs/p/12088209.html" class="p_n_p_prefix">» </a> 下一篇：    <a href="https://www.cnblogs.com/winton-nfs/p/12088209.html" title="发布于 2019-12-23 20:31">Mysql统计每年每个月的数据——详细教程</a>

</div>
</div>
            </div>
            <div class="postDesc">posted @ 
<span id="post-date">2019-09-15 20:13</span>&nbsp;
<a href="https://www.cnblogs.com/winton-nfs/">Winton-H</a>&nbsp;
阅读(<span id="post_view_count">322306</span>)&nbsp;
评论(<span id="post_comment_count">51</span>)&nbsp;
<a href="https://i.cnblogs.com/EditPosts.aspx?postid=11524007" rel="nofollow">编辑</a>&nbsp;
<a href="javascript:void(0)" onclick="AddToWz(11524007);return false;">收藏</a></div>
        </div>
	    
	    
    </div><!--end: topics 文章、评论容器-->
</div>
<script src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/highlight.min.js"></script>
<script>markdown_highlight();</script>
<script>
    var allowComments = true, cb_blogId = 523966, cb_blogApp = 'winton-nfs', cb_blogUserGuid = '355f0e15-6b97-45ad-41c6-08d6f93321fd';
    var cb_entryId = 11524007, cb_entryCreatedDate = '2019-09-15 20:13', cb_postType = 1;
    updatePostStats(
        [cb_entryId],
        function(id, count) { $("#post_view_count").text(count) },
        function(id, count) { $("#post_comment_count").text(count) })
</script>
<a name="!comments"></a>
<div id="blog-comments-placeholder">

<div id="comment_pager_top">
    
    <div class="pager">
        <!-- 上一页 -->
        <a href="https://www.cnblogs.com/winton-nfs/p/11524007.html#!comments" onclick="commentManager.renderComments(1, 50); return false;">
            &lt; Prev
        </a>

        <!-- 第一页 -->
        <a href="https://www.cnblogs.com/winton-nfs/p/11524007.html#!comments" onclick="commentManager.renderComments(1, 50); return false;">
            1
        </a>

        <!-- 前半部分页码 -->
        

        <!-- 当前页 -->
        <span class="current">2</span>

        <!-- 后半部分页码 -->

        
        <!-- 末尾页 -->
        

        <!-- 下一页 -->
        
    </div>
</div>

<br>
<div class="feedback_area_title">评论列表</div>
<div class="feedbackNoItems">
    <div class="feedbackNoItems"></div>
</div>
    <div class="feedbackItem">
        <div class="feedbackListSubtitle">
            <div class="feedbackManage">
                &nbsp;&nbsp;

<span class="comment_actions">
    
    
    
    
</span>


            </div>
            
<a href="https://www.cnblogs.com/winton-nfs/p/11524007.html#4739382" class="layer">#51楼</a>
<a name="4739382" id="comment_anchor_4739382"></a>
[<span class="louzhu">楼主</span>]    <span id="comment-maxId" style="display: none">4739382</span>
    <span id="comment-maxDate" style="display: none">2020/11/14 下午5:26:39</span>
 
<span class="comment_date">2020-11-14 17:26</span>

 
        <a id="a_comment_author_4739382" href="https://www.cnblogs.com/winton-nfs/" target="_blank">Winton-H</a>

        </div>
        <div class="feedbackCon">
            
<div id="comment_body_4739382" data-format-type="Markdown" class="blog_comment_body cnblogs-markdown">
    <p><a href="https://www.cnblogs.com/winton-nfs/p/11524007.html#4739231" title="查看所回复的评论" onclick="commentManager.renderComments(0,50,4739231);">@</a>la_via<br>
解决一：有可能是服务没安装正确，试试把之前的服务删掉，然后重新安装</p>
<p>解决二：手动开启服务<br>
1、Win+R ，输入services.msc，<br>
2、找到Mysql56,右击属性。<br>
3、点击登陆,点击本地系统登陆。<br>
4、回到服务启动MySql服务</p>

</div>
        <div class="comment_vote">
            <span class="comment_error" style="color: red"></span>
            <a href="javascript:void(0);" class="comment_digg" onclick="return voteComment(4739382, &#39;Digg&#39;, this.parentElement, false);">
                支持(0)
            </a>
            <a href="javascript:void(0);" class="comment_burry" onclick="return voteComment(4739382, &#39;Bury&#39;, this.parentElement, false);">
                反对(0)
            </a>
        </div>
        <span id="comment_4739382_avatar" style="display:none">
            https://pic.cnblogs.com/face/1727568/20190627202545.png
        </span>

        </div>
    </div>

<div id="comment_pager_bottom">
    
    <div class="pager">
        <!-- 上一页 -->
        <a href="https://www.cnblogs.com/winton-nfs/p/11524007.html#!comments" onclick="commentManager.renderComments(1, 50); return false;">
            &lt; Prev
        </a>

        <!-- 第一页 -->
        <a href="https://www.cnblogs.com/winton-nfs/p/11524007.html#!comments" onclick="commentManager.renderComments(1, 50); return false;">
            1
        </a>

        <!-- 前半部分页码 -->
        

        <!-- 当前页 -->
        <span class="current">2</span>

        <!-- 后半部分页码 -->

        
        <!-- 末尾页 -->
        

        <!-- 下一页 -->
        
    </div>
</div>


</div>
<div id="comment_form" class="commentform">
    <a name="commentform"></a>
    <div id="divCommentShow"></div>
    <div id="comment_nav"><span id="span_refresh_tips"></span><a href="javascript:void(0);" onclick="return RefreshCommentList();" id="lnk_RefreshComments" runat="server" clientidmode="Static">刷新评论</a><a href="https://www.cnblogs.com/winton-nfs/p/11524007.html#" onclick="return RefreshPage();">刷新页面</a><a href="https://www.cnblogs.com/winton-nfs/p/11524007.html#top">返回顶部</a></div>
    <div id="comment_form_container" style="visibility: visible;"><div class="login_tips">
    登录后才能发表评论，立即 <a rel="nofollow" href="javascript:void(0);" class="underline" onclick="return login(&#39;commentform&#39;);">登录</a> 或
    <a rel="nofollow" href="javascript:void(0);" class="underline" onclick="return register();">注册</a>，
    <a href="https://www.cnblogs.com/">访问</a> 网站首页
</div>
</div>
    <div class="ad_text_commentbox" id="ad_text_under_commentbox"></div>
    <div id="ad_t2"><a href="http://www.softbam.com/index.htm" target="_blank" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;T2-ucancode-1103&#39;)">【推荐】News: 大型组态、工控、仿真、CADGIS 50万行VC++源码免费下载</a><br><a href="https://www.cnblogs.com/himmr/p/14043893.html" target="_blank" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;T2-Himmr&#39;)">【推荐】博客园 &amp; 陌上花开HIMMR 给单身的程序员小哥哥助力脱单啦～</a><br><a href="https://brands.cnblogs.com/huawei" target="_blank" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;T2-华为专区&#39;)">【推荐】了不起的开发者，挡不住的华为，园子里的品牌专区</a><br><a href="https://brands.cnblogs.com/agora" target="_blank" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;T2-声网专区&#39;)">【推荐】未知数的距离，毫秒间的传递，声网与你实时互动</a><br></div>
    <div id="opt_under_post"></div>
    <div id="cnblogs_c1" class="c_ad_block">
        <div id="div-gpt-ad-1592365906576-0" style="width: 300px; height: 250px;" data-google-query-id="CNTs0vfMq-0CFYUFXAodEHECQA"><div id="google_ads_iframe_/1090369/C1_0__container__" style="border: 0pt none;"><iframe id="google_ads_iframe_/1090369/C1_0" title="3rd party ad content" name="google_ads_iframe_/1090369/C1_0" width="300" height="250" scrolling="no" marginwidth="0" marginheight="0" frameborder="0" data-google-container-id="1" style="border: 0px; vertical-align: bottom;" data-load-complete="true" src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/saved_resource.html"></iframe></div></div>
    </div>
    <div id="under_post_news"><div class="recomm-block"><b>相关博文：</b><br>·  <a title="【转】MySQL的安装与配置——详细教程-window系统下" href="https://www.cnblogs.com/wangcp-2014/p/12073006.html" target="_blank" onclick="clickRecomItmem(12073006)">【转】MySQL的安装与配置——详细教程-window系统下</a><br>·  <a title="mysql-5.7.28-winx64(压缩包)安装教程" href="https://www.cnblogs.com/shyw/p/12056419.html" target="_blank" onclick="clickRecomItmem(12056419)">mysql-5.7.28-winx64(压缩包)安装教程</a><br>·  <a title="cmd中输入netstartmysql提示：服务名无效或者MySQL正在启动MySQL无法启动" href="https://www.cnblogs.com/0901-hcx/p/11580756.html" target="_blank" onclick="clickRecomItmem(11580756)">cmd中输入netstartmysql提示：服务名无效或者MySQL正在启动MySQL无法启动</a><br>·  <a title="MySQL初始化root密码以及root密码忘记解决方法" href="https://www.cnblogs.com/xusx2014/p/4112582.html" target="_blank" onclick="clickRecomItmem(4112582)">MySQL初始化root密码以及root密码忘记解决方法</a><br>·  <a title="win10安装mysql8.0.18解决Navicat初次连接报错" href="https://www.cnblogs.com/111testing/p/11980340.html" target="_blank" onclick="clickRecomItmem(11980340)">win10安装mysql8.0.18解决Navicat初次连接报错</a><br>»  <a target="_blank" href="https://recomm.cnblogs.com/blogpost/11524007">更多推荐...</a></div></div>
    <div id="cnblogs_c2" class="c_ad_block"><a href="https://brands.cnblogs.com/aws/free" target="_blank"><img width="468" height="60" src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/2016690-20201107113124642-85659290.png" alt="AWS免费套餐" onclick="ga(&#39;send&#39;, &#39;event&#39;, &#39;Link&#39;, &#39;click&#39;, &#39;C2-AWS&#39;);"></a></div>
    <div id="under_post_kb">
<div class="itnews c_ad_block">
    <b>最新 IT 新闻</b>:
    <br>
 ·          <a href="https://news.cnblogs.com/n/678427/" target="_blank">美股收盘全线下跌 阿里大跌近5％ 理想汽车跌超8％</a>
        <br>
 ·          <a href="https://news.cnblogs.com/n/678423/" target="_blank">经济日报评论：理性应对浑水做空中概股</a>
        <br>
 ·          <a href="https://news.cnblogs.com/n/678413/" target="_blank">比特币价格今年暴涨1.5倍：2万美元指日可待</a>
        <br>
 ·          <a href="https://news.cnblogs.com/n/678411/" target="_blank">李学凌再造YY：YY从哪里来，又将到哪里去？</a>
        <br>
 ·          <a href="https://news.cnblogs.com/n/678410/" target="_blank">京东P7员工被辞退：赢了三次官司 却输了人生</a>
        <br>
    » <a href="https://news.cnblogs.com/" title="IT 新闻" target="_blank">更多新闻...</a>
</div></div>
    <div id="HistoryToday" class="c_ad_block"></div>
    <script type="text/javascript">
       var commentManager = new blogCommentManager();
       commentManager.renderComments(0);
       fixPostBody();
       deliverBigBanner();
setTimeout(function() { incrementViewCount(cb_entryId); }, 50);       deliverT2();
       deliverC1C2();
       loadNewsAndKb();
       loadBlogSignature();
LoadPostCategoriesTags(cb_blogId, cb_entryId);       LoadPostInfoBlock(cb_blogId, cb_entryId, cb_blogApp, cb_blogUserGuid);
       GetPrevNextPost(cb_entryId, cb_blogId, cb_entryCreatedDate, cb_postType);
       loadOptUnderPost();
       GetHistoryToday(cb_blogId, cb_blogApp, cb_entryCreatedDate);
   </script>
</div>

	</div><!--end: forFlow -->
	</div><!--end: mainContent 主体内容容器-->
	<div id="sideBar">
		<div id="sideBarMain">
			<div id="sidebar_news" class="newsItem"><!--done-->
<h3 class="catListTitle">公告</h3>

<div id="blog-news">
    
    <div id="profile_block">
        昵称：
        <a href="https://home.cnblogs.com/u/winton-nfs/">
            Winton-H
        </a>
        <br>
        园龄：
        <a href="https://home.cnblogs.com/u/winton-nfs/" title="入园时间：2019-06-27">
            1年5个月
        </a>
        <br>
        粉丝：
        <a href="https://home.cnblogs.com/u/winton-nfs/followers/">
            68
        </a>
        <br>
        关注：
        <a href="https://home.cnblogs.com/u/winton-nfs/followees/">
            9
        </a>
        <div id="p_b_follow">
<a href="javascript:void(0)" onclick="follow(&#39;355f0e15-6b97-45ad-41c6-08d6f93321fd&#39;)">+加关注</a></div>
        <script>getFollowStatus('355f0e15-6b97-45ad-41c6-08d6f93321fd');</script>
    </div>
</div>

</div>
<div id="sidebar_c3" style="display: block;"><div id="cnblogs_c3">
</div></div>
			<div id="blog-calendar" style="">

<table id="blogCalendar" class="Cal" cellspacing="0" cellpadding="0" title="Calendar" border="0">
    <tbody>
        <tr>
            <td colspan="7">
                <table class="CalTitle" cellspacing="0" border="0">
                    <tbody>
                        <tr>
                            <td class="CalNextPrev">
                                <a href="javascript:void(0);" onclick="loadBlogCalendar(&#39;2020/11/01&#39;); return false;">&lt;</a>
                            </td>
                            <td align="center">2020年12月</td>
                            <td align="right" class="CalNextPrev">
                                <a href="javascript:void(0);" onclick="loadBlogCalendar(&#39;2021/01/01&#39;); return false;">&gt;</a>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </td>
        </tr>
    <tr>
        <th class="CalDayHeader" align="center" abbr="日" scope="col">日</th>
        <th class="CalDayHeader" align="center" abbr="一" scope="col">一</th>
        <th class="CalDayHeader" align="center" abbr="二" scope="col">二</th>
        <th class="CalDayHeader" align="center" abbr="三" scope="col">三</th>
        <th class="CalDayHeader" align="center" abbr="四" scope="col">四</th>
        <th class="CalDayHeader" align="center" abbr="五" scope="col">五</th>
        <th class="CalDayHeader" align="center" abbr="六" scope="col">六</th>
    </tr>
            <tr>
                            <td class="CalOtherMonthDay" align="center">29</td>
                            <td class="CalOtherMonthDay" align="center">30</td>
                        <td class="CalTodayDay" align="center">
                            1
                        </td>
                        <td class="" align="center">
                            2
                        </td>
                        <td class="" align="center">
                            3
                        </td>
                        <td class="" align="center">
                            4
                        </td>
                    <td class="CalWeekendDay" align="center">
                        5
                    </td>
            </tr>
                <tr>
                        <td class="CalWeekendDay" align="center">
                            6
                        </td>
                            <td class="" align="center">
                                7
                            </td>
                            <td class="" align="center">
                                8
                            </td>
                            <td class="" align="center">
                                9
                            </td>
                            <td class="" align="center">
                                10
                            </td>
                            <td class="" align="center">
                                11
                            </td>
                        <td class="CalWeekendDay" align="center">
                            12
                        </td>
                </tr>
                <tr>
                        <td class="CalWeekendDay" align="center">
                            13
                        </td>
                            <td class="" align="center">
                                14
                            </td>
                            <td class="" align="center">
                                15
                            </td>
                            <td class="" align="center">
                                16
                            </td>
                            <td class="" align="center">
                                17
                            </td>
                            <td class="" align="center">
                                18
                            </td>
                        <td class="CalWeekendDay" align="center">
                            19
                        </td>
                </tr>
                <tr>
                        <td class="CalWeekendDay" align="center">
                            20
                        </td>
                            <td class="" align="center">
                                21
                            </td>
                            <td class="" align="center">
                                22
                            </td>
                            <td class="" align="center">
                                23
                            </td>
                            <td class="" align="center">
                                24
                            </td>
                            <td class="" align="center">
                                25
                            </td>
                        <td class="CalWeekendDay" align="center">
                            26
                        </td>
                </tr>
                <tr>
                        <td class="CalWeekendDay" align="center">
                            27
                        </td>
                            <td class="" align="center">
                                28
                            </td>
                            <td class="" align="center">
                                29
                            </td>
                            <td class="" align="center">
                                30
                            </td>
                            <td class="" align="center">
                                31
                            </td>
                            <td class="CalOtherMonthDay" align="center">
                                1
                            </td>
                        <td class="CalOtherMonthDay" align="center">
                            2
                        </td>
                </tr>
                <tr>
                        <td class="CalOtherMonthDay" align="center">
                            3
                        </td>
                            <td class="CalOtherMonthDay" align="center">
                                4
                            </td>
                            <td class="CalOtherMonthDay" align="center">
                                5
                            </td>
                            <td class="CalOtherMonthDay" align="center">
                                6
                            </td>
                            <td class="CalOtherMonthDay" align="center">
                                7
                            </td>
                            <td class="CalOtherMonthDay" align="center">
                                8
                            </td>
                        <td class="CalOtherMonthDay" align="center">
                            9
                        </td>
                </tr>
    </tbody>
</table></div><script>loadBlogDefaultCalendar();</script>			
			<div id="leftcontentcontainer">
				<div id="blog-sidecolumn"><!-- 搜索 -->
<div id="sidebar_search" class="sidebar-block">
    <div id="sidebar_search" class="mySearch">
        <h3 class="catListTitle">搜索</h3>
        <div id="sidebar_search_box">
            <div id="widget_my_zzk" class="div_my_zzk">
                <input type="text" id="q" onkeydown="return zzk_go_enter(event);" class="input_my_zzk">&nbsp;<input onclick="zzk_go()" type="button" value="找找看" id="btnZzk" class="btn_my_zzk">
            </div>
            <div id="widget_my_google" class="div_my_zzk">
                <input type="text" name="google_q" id="google_q" onkeydown="return google_go_enter(event);" class="input_my_zzk">&nbsp;<input onclick="google_go()" type="button" value="谷歌搜索" class="btn_my_zzk">
            </div>
        </div>
    </div>
</div>

<!-- 常用链接 -->
<div id="sidebar_shortcut" class="sidebar-block"><div class="catListLink">
<h3 class="catListTitle">
常用链接
</h3>
<ul>
    
<li><a href="https://www.cnblogs.com/winton-nfs/p/" title="我的博客的随笔列表">我的随笔</a></li>
<li><a href="https://www.cnblogs.com/winton-nfs/MyComments.html" title="我的发表过的评论列表">我的评论</a></li>
<li><a href="https://www.cnblogs.com/winton-nfs/OtherPosts.html" title="我评论过的随笔列表">我的参与</a></li>
<li><a href="https://www.cnblogs.com/winton-nfs/RecentComments.html" title="我的博客的评论列表">最新评论</a></li>
<li><a href="https://www.cnblogs.com/winton-nfs/tag/" title="我的博客的标签列表">我的标签</a></li>

</ul>
</div>

</div>

<!-- 最新随笔 -->


<!-- 我的标签 -->
<div id="sidebar_toptags" class="sidebar-block"></div>

<!-- 积分与排名 -->


<!-- 随笔分类、随笔档案、文章分类、新闻分类、相册、链接 -->
<div id="sidebar_categories">
        <div id="sidebar_postcategory" class="catListPostCategory sidebar-block">
            <h3 class="catListTitle">
                
随笔分类



            </h3>


            <ul>

                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/category/1879729.html" rel="" target="">
    Guice(1)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/category/1540617.html" rel="" target="">
    JavaWeb(5)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/category/1865189.html" rel="" target="">
    安装教程(1)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/category/1774505.html" rel="" target="">
    个人纪录(3)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/category/1774503.html" rel="" target="">
    前端技术(1)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/category/1543851.html" rel="" target="">
    数据库(4)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/category/1619283.html" rel="" target="">
    统计图(1)
</a>
 

                        </li>

            </ul>


        </div>
        <div id="sidebar_postarchive" class="catListPostArchive sidebar-block">
            <h3 class="catListTitle">
                
随笔档案



            </h3>


            <ul>

                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/archive/2020/11.html" rel="" target="">
    2020年11月(1)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/archive/2020/10.html" rel="" target="">
    2020年10月(2)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/archive/2020/05.html" rel="" target="">
    2020年5月(2)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/archive/2020/04.html" rel="" target="">
    2020年4月(1)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/archive/2019/12.html" rel="" target="">
    2019年12月(2)
</a>
 

                        </li>
                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/archive/2019/09.html" rel="" target="">
    2019年9月(6)
</a>
 

                        </li>

            </ul>


        </div>
        <div id="sidebar_imagecategory" class="catListImageCategory sidebar-block">
            <h3 class="catListTitle">
                
相册



            </h3>


            <ul>

                        <li>
                            
<a href="https://www.cnblogs.com/winton-nfs/gallery/1569219.html" rel="nofollow noopener noreferrer" target="">
    背景图(3)
</a>
 

                        </li>

            </ul>


        </div>
</div>

<!-- 最新评论 -->
<div id="sidebar_recentcomments" class="sidebar-block"><div class="catListComment">
<h3 class="catListTitle">最新评论</h3>

	<div class="RecentCommentBlock">
        <ul>
                    <li class="recent_comment_title"><a href="https://www.cnblogs.com/winton-nfs/p/12956811.html">1. Re:解决mysql：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES)</a></li>
                    <li class="recent_comment_body">@张卓涵 什么2003，方便截图看看？...</li>
                    <li class="recent_comment_author">--Winton-H</li>
                    <li class="recent_comment_title"><a href="https://www.cnblogs.com/winton-nfs/p/12956811.html">2. Re:解决mysql：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES)</a></li>
                    <li class="recent_comment_body"><p>好家伙直接2003</p>
</li>
                    <li class="recent_comment_author">--张卓涵</li>
                    <li class="recent_comment_title"><a href="https://www.cnblogs.com/winton-nfs/p/11524007.html">3. Re:MySQL的安装与配置——详细教程</a></li>
                    <li class="recent_comment_body">@la_via 解决一：有可能是服务没安装正确，试试把之前的服务删掉，然后重新安装 解决二：手动开启服务 1、Win+R ，输入services.msc， 2、找到Mysql56,右击属性。 3、点击...</li>
                    <li class="recent_comment_author">--Winton-H</li>
                    <li class="recent_comment_title"><a href="https://www.cnblogs.com/winton-nfs/p/11524007.html">4. Re:MySQL的安装与配置——详细教程</a></li>
                    <li class="recent_comment_body">@la_via 什么把mysql换成.\mysql ？ 方便截个图让我看看嘛...</li>
                    <li class="recent_comment_author">--Winton-H</li>
                    <li class="recent_comment_title"><a href="https://www.cnblogs.com/winton-nfs/p/11524007.html">5. Re:MySQL的安装与配置——详细教程</a></li>
                    <li class="recent_comment_body"><p>博主，刚开始安装服务和初始化的时候，报错让我把mysql换成.\mysql，试过之后这两步成功了，但是开启服务的时候显示服务无法开启，这是怎么回事。</p>
</li>
                    <li class="recent_comment_author">--la_via</li>
        </ul>
    </div>
</div>

</div>


<!-- 阅读排行榜 -->
<div id="sidebar_topviewedposts" class="sidebar-block"><div class="catListView">
<h3 class="catListTitle">阅读排行榜</h3>
	<div id="TopViewPostsBlock">
        <ul style="word-break:break-all">
                    <li>
                        <a href="https://www.cnblogs.com/winton-nfs/p/11524007.html">
                            1. MySQL的安装与配置——详细教程(322175)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/winton-nfs/p/12956811.html">
                            2. 解决mysql：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES)(11011)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/winton-nfs/p/12088209.html">
                            3. Mysql统计每年每个月的数据——详细教程(5710)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/winton-nfs/p/12715486.html">
                            4. IDEA永久激活码获取(2557)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/winton-nfs/p/11461161.html">
                            5. JavaWeb实现删除功能(2520)
                        </a>
                    </li>
        </ul>
    </div>
</div>

</div>

<!-- 评论排行榜 -->
<div id="sidebar_topcommentedposts" class="sidebar-block"><div class="catListFeedback">
<h3 class="catListTitle">评论排行榜</h3>
	<div id="TopFeedbackPostsBlock">
        <ul style="word-break:break-all">
                    <li>
                        <a href="https://www.cnblogs.com/winton-nfs/p/11524007.html">
                            1. MySQL的安装与配置——详细教程(51)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/winton-nfs/p/12956811.html">
                            2. 解决mysql：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES)(20)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/winton-nfs/p/12088209.html">
                            3. Mysql统计每年每个月的数据——详细教程(5)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/winton-nfs/p/11461161.html">
                            4. JavaWeb实现删除功能(3)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/winton-nfs/p/11457943.html">
                            5. JavaWeb实现查询功能(1)
                        </a>
                    </li>
        </ul>
    </div>
</div>

</div>

<!-- 推荐排行榜 -->
<div id="sidebar_topdiggedposts" class="sidebar-block">
<div id="topdigg_posts_wrap">
    <div class="catListView">
        <h3 class="catListTitle">推荐排行榜</h3>
        <div id="TopDiggPostsBlock">
            <ul style="word-break: break-all">
                        <li>
                            <a href="https://www.cnblogs.com/winton-nfs/p/11524007.html">
                                1. MySQL的安装与配置——详细教程(63)
                            </a>
                        </li>
                        <li>
                            <a href="https://www.cnblogs.com/winton-nfs/p/12088209.html">
                                2. Mysql统计每年每个月的数据——详细教程(3)
                            </a>
                        </li>
                        <li>
                            <a href="https://www.cnblogs.com/winton-nfs/p/12956811.html">
                                3. 解决mysql：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES)(2)
                            </a>
                        </li>
                        <li>
                            <a href="https://www.cnblogs.com/winton-nfs/p/11457943.html">
                                4. JavaWeb实现查询功能(1)
                            </a>
                        </li>
            </ul>
        </div>
    </div>
</div></div></div>
                    <script>loadBlogSideColumn();</script>
			</div>			
		</div><!--end: sideBarMain -->
	</div><!--end: sideBar 侧边栏容器 -->
	<div class="clear"></div>
	</div><!--end: main -->
	<div class="clear"></div>
	<div id="footer">
		<!--done-->
Copyright © 2020 Winton-H
<br><span id="poweredby">Powered by .NET 5.0.0 on Kubernetes</span>



	</div><!--end: footer -->
</div><!--end: home 自定义的最大容器 -->


    <div id="page_end_html">
        <script src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/L2Dwidget.min.js"></script>
<script type="text/javascript">
L2Dwidget.init();
</script>
<script src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/cursor-effects.js"></script>

<canvas width="1366" height="662" style="position: fixed; left: 0px; top: 0px; z-index: 2147483647; pointer-events: none;"></canvas>
    </div><canvas width="1366" height="597" style="position: fixed; left: 0px; top: 0px; z-index: 2147483647; pointer-events: none;"></canvas>


<div><object id="ClCache" click="sendMsg" host="" width="0" height="0"></object></div><div id="live2d-widget"><canvas id="live2dcanvas" width="300" height="600" style="position: fixed; opacity: 0.7; right: 0px; bottom: -20px; z-index: 99999; pointer-events: none; border: 1px dashed rgb(204, 204, 204);"></canvas></div><iframe id="google_osd_static_frame_9728633603321" name="google_osd_static_frame" style="display: none; width: 0px; height: 0px;" src="./MySQL的安装与配置——详细教程 - Winton-H - 博客园_files/saved_resource(1).html"></iframe></body></html>